<?php $all_session = $this->session->all_userdata(); ?>
<!DOCTYPE html>
<!-- saved from url=(0056)http://startbootstrap.com/templates/simple-sidebar.html# -->
<html lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="">
<meta name="author" content="">
<title>Timeline</title>
<script src="<?php echo base_url();?>js/chart.js"></script>
<?php $this->load->view('panel_head');?>
</head>

<body>
<style>
.dots {
	table-layout:fixed;
}

.dots p {
	white-space: nowrap;
	overflow: hidden;
	text-overflow: ellipsis;
}

.timeline {
    list-style: none;
    padding: 20px 0 20px;
    position: relative;
}

    .timeline:before {
        top: 0;
        bottom: 0;
        position: absolute;
        content: " ";
        width: 3px;
        background-color: #eeeeee;
        left: 50%;
        margin-left: -1.5px;
    }

    .timeline > li {
        margin-bottom: 20px;
        position: relative;
    }

        .timeline > li:before,
        .timeline > li:after {
            content: " ";
            display: table;
        }

        .timeline > li:after {
            clear: both;
        }

        .timeline > li:before,
        .timeline > li:after {
            content: " ";
            display: table;
        }

        .timeline > li:after {
            clear: both;
        }

        .timeline > li > .timeline-panel {
            width: 46%;
            float: left;
            border: 1px solid #d4d4d4;
            border-radius: 2px;
            padding: 20px;
            position: relative;
            -webkit-box-shadow: 0 1px 6px rgba(0, 0, 0, 0.175);
            box-shadow: 0 1px 6px rgba(0, 0, 0, 0.175);
        }

            .timeline > li > .timeline-panel:before {
                position: absolute;
                top: 26px;
                right: -15px;
                display: inline-block;
                border-top: 15px solid transparent;
                border-left: 15px solid #ccc;
                border-right: 0 solid #ccc;
                border-bottom: 15px solid transparent;
                content: " ";
            }

            .timeline > li > .timeline-panel:after {
                position: absolute;
                top: 27px;
                right: -14px;
                display: inline-block;
                border-top: 14px solid transparent;
                border-left: 14px solid #fff;
                border-right: 0 solid #fff;
                border-bottom: 14px solid transparent;
                content: " ";
            }

        .timeline > li > .timeline-badge {
            color: #fff;
            width: 50px;
            height: 50px;
            line-height: 50px;
            font-size: 1.4em;
            text-align: center;
            position: absolute;
            top: 16px;
            left: 50%;
            margin-left: -25px;
            background-color: #999999;
            z-index: 100;
            border-top-right-radius: 50%;
            border-top-left-radius: 50%;
            border-bottom-right-radius: 50%;
            border-bottom-left-radius: 50%;
        }

        .timeline > li.timeline-inverted > .timeline-panel {
            float: right;
        }

            .timeline > li.timeline-inverted > .timeline-panel:before {
                border-left-width: 0;
                border-right-width: 15px;
                left: -15px;
                right: auto;
            }

            .timeline > li.timeline-inverted > .timeline-panel:after {
                border-left-width: 0;
                border-right-width: 14px;
                left: -14px;
                right: auto;
            }

.timeline-badge.primary {
    background-color: #2e6da4 !important;
}

.timeline-badge.success {
    background-color: #3f903f !important;
}

.timeline-badge.warning {
    background-color: #f0ad4e !important;
}

.timeline-badge.danger {
    background-color: #d9534f !important;
}

.timeline-badge.info {
    background-color: #5bc0de !important;
}

.timeline-title {
    margin-top: 0;
    color: inherit;
}

.timeline-body > p,
.timeline-body > ul {
    margin-bottom: 0;
}

    .timeline-body > p + p {
        margin-top: 5px;
    }

@media (max-width: 767px) {
    ul.timeline:before {
        left: 40px;
    }

    ul.timeline > li > .timeline-panel {
        width: calc(100% - 90px);
        width: -moz-calc(100% - 90px);
        width: -webkit-calc(100% - 90px);
    }

    ul.timeline > li > .timeline-badge {
        left: 15px;
        margin-left: 0;
        top: 16px;
    }

    ul.timeline > li > .timeline-panel {
        float: right;
    }

        ul.timeline > li > .timeline-panel:before {
            border-left-width: 0;
            border-right-width: 15px;
            left: -15px;
            right: auto;
        }

        ul.timeline > li > .timeline-panel:after {
            border-left-width: 0;
            border-right-width: 14px;
            left: -14px;
            right: auto;
        }
}
</style>
<div style="height:46px; width:100%; position:fixed; z-index:10000;">
  <?php $this->load->view('header');?>
</div>
<div style="height:46px;"></div>








<div class="page-content inset">
  <div class="panel panel-default" style="margin-bottom:-2em;">
      
    <div class="container">
    <div class="page-header">
    
        <h1 id="timeline">Timeline</h1>
    </div>
    
    <?php date_default_timezone_set("Asia/Bangkok"); ?>
    <div align="center">
    <?php echo form_open('timeline/index'); ?>
        <select class="form-control" style="width:7em;" onChange="this.form.submit()" name="year">     
        <?php if(@$all_session['year'] != '') { ?>
          <option value=""> -- <?php echo $all_session['year']; ?> -- </option>
        <?php } else { ?>   
          <option value="<?php echo date("Y");?>"> -- <?php echo date("Y");?> -- </option>
        <?php } ?>
        <?php foreach($get_year as $get_year) { ?>
          <option value="<?php echo $get_year['YEAR(event_start)']; ?>"><?php echo $get_year['YEAR(event_start)']; ?></option>
          <?php } ?>
        </select>
    <?php echo form_close();?>
    </div>
    
    <?php 
		$full_month = array(
			'0' => 'January',
			'1' => 'February',
			'2' => 'March',
			'3' => 'April',
			'4' => 'May',
			'5' => 'June',
			'6' => 'July',
			'7' => 'August',
			'8' => 'September',
			'9' => 'October',
			'10' => 'November',
			'11' => 'December'
		);
		
		$month = array(
			'0' => 'Jan',
			'1' => 'Feb',
			'2' => 'Mar',
			'3' => 'Apr',
			'4' => 'May',
			'5' => 'Jun',
			'6' => 'Jul',
			'7' => 'Aug',
			'8' => 'Seย',
			'9' => 'Octr',
			'10' => 'Nov',
			'11' => 'Dec'
		);
	?>
  
    <ul class="timeline">
    
     <?php $a=0; $b=1; ?>
    <?php for($i=0;$i<12;$i++) { ?>
        <?php 
				$this->db->select('event_name ,event_start');	
				$this->db->where('vdo_status',0);			
				$this->db->where('MONTH(event_start)',$a+1);
				$this->db->where('YEAR(event_start)',$all_session['year']);
				$this->db->where_not_in('event_start' ,'');
				$this->db->group_by('event_name');
				$query = $this->db->get('vdo');
				$data = $query->result_array();
		?>
        
        <?php if($data != NULL) { ?>
        <li>
          <div class="timeline-badge"><?php echo $month[$a]; ?></div>
          <div class="timeline-panel">
            <div class="timeline-heading">
              <h4 class="timeline-title"><?php echo $full_month[$a]; ?></h4></p>
             
            </div>
            <div class="timeline-body">
            <ul>
            <?php foreach($data as $data) { ?>
            	<li><a href="<?php echo base_url();?>index.php/timeline/event/<?php echo $all_session['year'];?>/<?php echo $a+1; ?>/<?php echo $data['event_name'];?>"><?php echo $data['event_name'];?></a></li>
            <?php } ?>
            </ul>
            </div>
          </div>
        </li>
        <?php } ?>
        
        
         <?php 
				$this->db->select('event_name ,event_start');
				$this->db->where('vdo_status',0);				
				$this->db->where('MONTH(event_start)',$b+1);
				$this->db->where('YEAR(event_start)',$all_session['year']);
				$this->db->where_not_in('event_start' ,'');
				$this->db->group_by('event_name');
				$query = $this->db->get('vdo');
				$data = $query->result_array();
				
		?>
        <?php if($data != NULL) { ?>
      
        <li class="timeline-inverted">
          <div class="timeline-badge"><?php echo $month[$b]; ?></div>
          <div class="timeline-panel">
            <div class="timeline-heading">
              <h4 class="timeline-title"><?php echo $full_month[$b]; ?></h4>
            </div>
            <div class="timeline-body">
              <ul>
            <?php foreach($data as $data) { ?>
            	<li><a href="<?php echo base_url();?>index.php/timeline/event/<?php echo $all_session['year'];?>/<?php echo $b+1; ?>/<?php echo $data['event_name'];?>"><?php echo $data['event_name'];?></a></li>
            <?php } ?>
            </ul>
            </div>
          </div>
        </li>
    	<?php } ?>
        
          <?php $a+=2; $b+=2; ?>
         <?php $i++; } ?>
      
    </ul>
   
    
    
    
</div>


      
    </div>
  </div>
</div>

</body>
</html>